package com.lakers.notice.springboot.db;

/**
 * 功能描述: SqlStatement
 *
 * @author liqin(zxl)
 * @date 2024/5/3
 */
public class SqlStatement {

    public static final String INSERT_SQL = "insert into tb_notice_message(send_id,recv_ids,content,business_type,business_id,type)" +
            " values(?,?,?,?,?,?)";


    public static final String INSERT_USER_SQL = "insert into tb_notice_user(notice_id,user_id) values(?,?)";


    public static final String SELECT_NOTICE_USER_SQL = "select notice_id from tb_notice_user where notice_id in (%s) and  user_id = '%s'";


    public static final String SELECT_MESSAGE_LIST_SQL = "select send_id, content,business_type, business_id,send_time,id,type from tb_notice_message t  where 1=1 ";


    public static final String SELECT_MESSAGE_COUNT_SQL = "select count(1) from tb_notice_message t  where 1=1 ";





}


